/*
 * Copyright 2013-2019 Xia Jun(3979434@qq.com).
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 ***************************************************************************************
 *                                                                                     *
 *                        Website : http://www.farsunset.com                           *
 *                                                                                     *
 ***************************************************************************************
 */
package com.workcell.workdata.im.repository;

import com.workcell.workdata.im.constant.RobotState;
import com.workcell.workdata.im.entity.GroupRobot;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;

@Repository
@Transactional(rollbackFor = Exception.class)
public interface GroupRobotRepository extends JpaRepository<GroupRobot, Long> {

	@Query("from GroupRobot   where groupId = ?1 order by id desc")
	List<GroupRobot> findList(Long groupId);

	@Query("from GroupRobot   where groupId in(?1) order by id desc")
	List<GroupRobot> findList(List<Long> idList);

	@Query("select id from GroupRobot where groupId = :groupId and uid in(:uidList)")
	List<Long> findIdList(Long groupId, List<Long> uidList);

	@Modifying
	@Query("update GroupRobot set uid = :uid where  id in(:idList)")
	void transfer(List<Long> idList, Long uid);

	@Modifying
	@Query("delete from GroupRobot where groupId = ?1")
	void remove(Long groupId);

	@Modifying
	@Query("update GroupRobot set state = "+ RobotState.DISABLED+" where  id=?1")
	void disable(Long id);

	@Modifying
	@Query("update GroupRobot set state = "+ RobotState.ENABLE+" where  id=?1")
	void enable(Long id);

	@Query("from GroupRobot where uuid = ?1")
	GroupRobot findByUuid(String uuid);
	@Query("select groupId from GroupRobot where id = :id")
	Long findGroupId(long id);
}
